<?php

namespace App\Controller\Example;

class CtcOrdersExample extends BaseExample
{
    /**
     * 数据库实例
     * */
    public $id;// int(11) NOT NULL AUTO_INCREMENT COMMENT '订单索引id',
    public $sn;// char(100) DEFAULT NULL COMMENT '订单编号',
    public $wid;// int(10) unsigned NOT NULL DEFAULT '1' COMMENT '币种类型（1：CNY 2: USDT 3:MYR）',
    public $type;// int(10) unsigned DEFAULT '1' COMMENT '买卖类型（1：卖，2买）',
    public $user_id;// int(11) NOT NULL DEFAULT '0' COMMENT '下单id',
    public $uid;// int(10) unsigned NOT NULL COMMENT '买家id',
    public $buy_name;// varchar(12) CHARACTER SET utf8 DEFAULT '' COMMENT '买家姓名',
    public $buy_mobile;// varchar(12) CHARACTER SET utf8 DEFAULT '' COMMENT '买家电话',
    public $buy_white;// tinyint(1) DEFAULT '0' COMMENT '买家白名单',
    public $to_uid;// int(10) unsigned NOT NULL COMMENT '卖家id',
    public $sell_name;// varchar(12) CHARACTER SET utf8 DEFAULT '' COMMENT '卖家姓名',
    public $sell_mobile;// varchar(12) CHARACTER SET utf8 DEFAULT '' COMMENT '卖家电话',
    public $sell_white;// tinyint(1) DEFAULT '0' COMMENT '卖家白名单',
    public $goods_id;// int(10) unsigned DEFAULT '1' COMMENT '信息ID',
    public $quantity;// decimal(18,4) unsigned DEFAULT '0.0000' COMMENT '交易总数',
    public $price;// decimal(12,4) unsigned DEFAULT '0.0000' COMMENT '单价',
    public $total_price;// decimal(12,2) DEFAULT '0.00' COMMENT '总价格',
    public $commission;// decimal(12,4) DEFAULT '0.0000' COMMENT '手续费',
    public $commission_type;// tinyint(1) DEFAULT '0' COMMENT '手续费类型',
    public $group_id;// tinyint(1) DEFAULT '0' COMMENT '群主信息',
    public $payment;// varchar(50) CHARACTER SET utf8 DEFAULT '' COMMENT '收款方式（1：银行卡  2：支付宝  3：微信）',
    public $pay_type;// int(10) unsigned DEFAULT '1' COMMENT '凭证类型（1：银行卡  2：支付宝  3：微信）',
    public $certificate;// mediumtext CHARACTER SET utf8 COMMENT '上传凭证',
    public $pay_status;// tinyint(3) unsigned DEFAULT '0' COMMENT '凭证状态：1已经上传，2无效',
    public $mark;// varchar(150) CHARACTER SET utf8 DEFAULT NULL COMMENT '描述',
    public $status;// tinyint(3) unsigned DEFAULT '10' COMMENT '订单状态：0(已取消)10(默认):未付款;20:已付款;30:已完成',
    public $appeal;// tinyint(3) unsigned DEFAULT '0' COMMENT '上诉状态：0未上诉，1已上诉，2已完成',
    public $finnshed_time;// int(10) unsigned DEFAULT '0' COMMENT '订单完成时间',
    public $create_time;// int(10) unsigned NOT NULL COMMENT '添加时间',
    public $update_time;// int(10) unsigned NOT NULL COMMENT '编辑时间',
}